2015-03-02 - 16486.300 - Spec - Post Inbound EDI Orders having invalid season - (Craig by 2015-03-27) #abapquality #EDISD #OrderEntry #salesorders

SPECIFICATIONS

16486.300 - Spec - Force in Season with rejection reason


Purpose

Process inbound EDI orders having invalid season.

Admin Info

Purpose
 Process inbound EDI orders having invalid season
Requested By
 Craig Spangler
Spec Created By
 Surya Basa
Spec Created Date
 02/27/2015
Spec QA by
 Surya Basa
Objects
 EXIT_SAPLJ4AS_004,Z_INV_SEASON_DETER
Document Status
 WIP


Estimates


Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 08
3
 Development/ Config
 40
4
 Unit test in DEV
 16
5
 Unit test in QUA
 16
6
 Other activity

TOTAL
 88

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

NA

Documents

[Attach any document(s) received for the requirement(s)]

NA



Spec Changes

[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any
1
 Update the delivery block ZS at header in the SO if any item in the SO has the rejection reason ZS.
 Craig Spangler
 03-31-2015
 NA
2
 The ZD rejection reason should overwrite ZS rejection reason if it is paased in the IDOC for the future requested del.date
 Craig Spangler
 04-07-2015
 NA
3
 The past requested Delivery date and the cancel dates should be bumped to future to 180 and 210 days respectively.If any one of the two days is bumped to future then the ZD rejection reason should be placed at the item level irrespective of season validity.
 Craig Spangler
 04-23-2015
 NA










Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

IB EDI orders with invalid seasons are causing the IDOCs to fail thereby requiring customer service to analyze them; check with customer and make changes to the IDOCs and reprocess them. This causes undue delay and requires resources and additional time to process them.

The proposed solution will post the IDOCs successfully overriding the failure of IDOCs and allowing customer service to handle them in a more efficient manner.

In Scope:

[List the activities to be included in scope]

- The changes would be restricted to EDI orders coming into SAP with IDOC type /AFS/ORDERS05.
- The change will check for the season validity based on the UPC in the IDOC.

Out of Scope:

[Out of scope activities]

Manual orders processing will not be impacted by this change and standard

Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

The solution involves modification of User Exit and implementation of Implicit Enhancement ( Enhancement Spot )

1) Check if the Material in the IDOC has a valid season and if Valid season is not found add rejection reason 'ZS'. This change should be done in User Exit.
2) For the line items which have Rejection Reason 'ZS' from above step, change the Season Determination status from ERROR to Information. This change is done in Implicit Enhancement.

User Exit: EXIT_SAPLJ4AS_004
Implicit Enhancement: Z_INV_SEASON_DETER

3)The delivery block ZS should be added in the sales order header if any of the item in the SO is rejected by ZS rejection reason.User will manually remove the delivery block and redetermine the valid season for the rejected items.This will help is avoiding creation of partial deliveries.

4) The past requested delivery date and the cancel date should be bumped to 180 and 210 days future respectively from the date of IDOC processing.The rejection reason ZD should be added at the item level irrespective of season validity and the ZS delivery block should still appear in the header.

Test Plan

[List test scenarios/cases to be executed here]

S.No
 Test Scenario
 Expected Result
SD-001
 1. Create an EDI order with doc type ZOR with an invalid sea-col using one UPC #
2. Add another valid season in the material master and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level.The invalid season/col shouldn't be displayed at the item/size level.The delivery block ZS should be displayed at header level
2 .A new valid season is added in the material and this should be displayed after removing the rejection reason ZS at item level.
3. Billing document should be created successfully
SD-002
 1. Create an EDI order with doc type ZOR with an invalid sea-col using two UPC # of two different materials.
2. Add another valid season/collection in the material master for both the materials and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level.The invalid season/col shouldn't be displayed at the item/size level for both the materials.The delivery block ZS should be displayed at header level
2 .A new valid season is added in the materials and this should be displayed after removing the rejection reason ZS at item level.
3. Billing document should be created successfully
SD-003
 1. Create an EDI order with doc type ZOR with an invalid and valid sea-col using two UPC # of two different materials.
2. Add a valid season/collection in the material master for the invalid sea-col material and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level for the invalid sea-col material.The invalid season/col shouldn't be displayed at the item/size level for the material. 2.The delivery block ZS should be displayed at header level 3. For the valid sea-col material the rejection reason ZS shouldn't be displayed and the respective sea-col should be displayed at item/size level.
4 .A new valid season is added in the material and this should be displayed after removing the rejection reason ZS at item level.
5. Billing document should be created successfully
SD-004
 1. Create an EDI order with doc type ZOR with one valid sea-col using one UPC #

2. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with a valid sea-col at item/size level and the rejection reason ZS shouldn't be displayed.The delivery block ZS shouldn't be displayed at header level.

2. Billing document should be created successfully
SD-005
 Create an manual order with doc type ZOR with an invalid sea-col material.
 The SO should not be created and an error is displayed as 'No season found for material '
SD-006
 1. Create an EDI order with doc type ZJRU with an invalid sea-col using one UPC #
2. Add another valid season in the material master and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level.The invalid season/col shouldn't be displayed at the item/size level.The delivery block ZS should be displayed at header level
2 .A new valid season is added in the material and this should be displayed after removing the rejection reason ZS at item level.
3. Delivery and Billing document should be created successfully
SD-007
 1. Create an EDI order with doc type ZJRU with an invalid sea-col using two UPC # of two different materials.
2. Add another valid season/collection in the material master for both the materials and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level.The invalid season/col shouldn't be displayed at the item/size level for both the materials.The delivery block ZS should be displayed at header level
2 .A new valid season is added in the materials and this should be displayed after removing the rejection reason ZS at item level. 3. Delivery and Billing document should be created successfully
SD-008
 1. Create an EDI order with doc type ZJRU with an invalid and valid sea-col using two UPC # of two different materials.
2. Add a valid season/collection in the material master for the invalid sea-col material and remove the rejection reason ZS at item level in the Sales order.
3. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with rejection reason ZS at size and item level for the invalid sea-col material.The invalid season/col shouldn't be displayed at the item/size level for the material.The delivery block ZS should be displayed at header level. 2. For the valid sea-col material the rejection reason ZS shouldn't be displayed and the respective sea-col should be displayed at item/size level.
3 .A new valid season is added in the material and this should be displayed after removing the rejection reason ZS at item level.
4. Delivery and Billing document should be created successfully
SD-009
 1. Create an EDI order with doc type ZJRU with one valid sea-col using one UPC #

2. Complete the cycle to create the billing document
 1. IDOC should be posted successfully and sales document created with a valid sea-col at item/size level and the rejection reason ZS shouldn't be displayed.The delivery block ZS shouldn't be displayed at header level

2. Billing document should be created successfully
SD-010
 Create an manual order with doc type ZJRU with an invalid sea-col material.
 The SO should not be created and an error is displayed as 'No season found for material '
SD-011
 Create EDI order as below. A.Material with invalid season and ZD rejection reason in the IDOC.
 The SO should be created with ZD rejection reason at the item level with blank season/collection.The delivery block ZS should be dispalyed at header level in the SO.
SD-012
 Create EDI order as below. A.Material with invalid season and ZD rejection reason in the IDOC B.material with valid season and ZD rejection reason in the IDOC.
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be dispalyed at item level with corresponding season/collection. The delivery block ZS should be dispalyed at header level in the SO.
SD-013
 Create EDI order as below. A.Material with invalid season and ZD rejection reason in the IDOC B.material with valid season and ZD rejection reason in the IDOC. C.Material with valid season without any rejection reason in the IDOC. D.material withinvalid season without any rejection reason in the IDOC
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be dispalyed at item level with corresponding season/collection. C.Rejection reason shouldn't be displayed at the item level. D.The rejection reason ZS should be displayed without any season/collection. The delivery block ZS should be dispalyed at header level in the SO.
SD-014
 Create EDI order with Material with invalid season without ZD rejection reason in the IDOC .
 The SO should be created with the rejection reason ZS at the item level with blank season/collection. The delivery block ZS should be dispalyed at header level in the SO.
SD-015
 Create EDI order with Material with valid season without ZD rejection reason in the IDOC .
 The SO should be created without any rejection reason at the item level with valid season/collection. The delivery block ZS shouldn't be dispalyed at header level in the SO.
SD-016
 1. Create an EDI Contract with doc type ZCQ with an invalid sea-col using one UPC #
2. Add another valid season in the material master and remove the rejection reason ZS at item level in the contract.
 1. IDOC should be posted successfully and contract is created with rejection reason ZS at size and item level.The invalid season/col shouldn't be displayed at the item/size level.The delivery block ZS should be displayed at header level
2 .A new valid season is added in the material and this should be displayed after removing the rejection reason ZS at item level.
SD - 017
 Create EDI Contract ZCQ as below. A.Material with invalid season and ZD rejection reason in the IDOC B.material with valid season and ZD rejection reason in the IDOC.
 The Contract should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be dispalyed at item level with corresponding season/collection. The delivery block ZS should be dispalyed at header level in the contract.
Test Scenarios for the past Requested Del.date and cancel date with ZD rejection reason.
S.No
 Test Scenario
 Expected Result
SD-001
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With the requested Delivery date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days in future at both header and item level.
SD-002
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With the cancel date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The cancel date should be changed to 180 days in future at both header and item level.
SD-003
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With both requested and cancel dates in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future .Both the changed dates should be displayed at header and item level.
SD-004
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC B.material with valid season in the IDOC. C.With both requested and cancel dates in past.
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be displayed at item level with corresponding season/collection.The delivery block ZS should be displayed at header level in the SO. C.The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future D.Both the changed dates should be displayed at header and item level.
SD-005
 Create EDI Contract ZCQ as below. A.Material with invalid season in the IDOC. B.With the requested Delivery date in past.
 The Contract should be created with ZD rejection reaContractn at the item level with blank seaContractn/collection. The delivery block ZS should be displayed at header level in the Contract. The requested delivery date should be changed to 180 days in future at both header and item level.
SD-006
 Create EDI Contract ZCQ as below. A.Material with invalid season in the IDOC. B.With the cancel date in past.
 The Contract should be created with ZD rejection reaContractn at the item level with blank seaContractn/collection. The delivery block ZS should be displayed at header level in the Contract. The cancel date should be changed to 180 days in future at both header and item level.
SD-007
 Create EDI Contract ZCQ as below. A.Material with invalid season in the IDOC. B.With both requested and cancel dates in past.
 The Contract should be created with ZD rejection reaContractn at the item level with blank seaContractn/collection. The delivery block ZS should be displayed at header level in the Contract. The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future .Both the changed dates should be displayed at header and item level.
SD-008
 Create EDI Contract ZCQ as below. A.Material with invalid season in the IDOC B.material with valid season in the IDOC. C.With both requested and cancel dates in past.
 The Contract should be created as below. A.The rejection reaContractn ZD should be displayed at the item level with blank seaContractn/collection. B.The rejection reaContractn ZD should be displayed at item level with corresponding seaContractn/collection.The delivery block ZS should be displayed at header level in the Contract. C.The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future D.Both the changed dates should be displayed at header and item level.
SD-009
 Create EDI Rush Order ZJRU as below. A.Material with invalid season in the IDOC. B.With the requested Delivery date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days in future at both header and item level.Delivery Shouldn't be created.
SD-010
 Create EDI Rush Order ZJRU as below. A.Material with invalid season in the IDOC. B.With the cancel date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The cancel date should be changed to 180 days in future at both header and item level.Delivery Shouldn't be created.
SD-011
 Create EDI Rush Order ZJRU as below. A.Material with invalid season in the IDOC. B.With both requested and cancel dates in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future .Both the changed dates should be displayed at header and item level.Delivery Shouldn't be created.
SD-012
 Create EDI Rush Order ZJRU as below. A.Material with invalid season in the IDOC B.material with valid season in the IDOC. C.With both requested and cancel dates in past.
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be displayed at item level with corresponding season/collection.The delivery block ZS should be displayed at header level in the SO. C.The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future D.Both the changed dates should be displayed at header and item level.Delivery Shouldn't be created.
SD-013
 Create EDI Order ZU3P as below. A.Material with invalid season in the IDOC. B.With the requested Delivery date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days in future at both header and item level.
SD-014
 Create EDI Order ZU3P as below. A.Material with invalid season in the IDOC. B.With the cancel date in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The cancel date should be changed to 180 days in future at both header and item level.
SD-015
 Create EDI Order ZU3P as below. A.Material with invalid season in the IDOC. B.With both requested and cancel dates in past.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future .Both the changed dates should be displayed at header and item level.
SD-016
 Create EDI Order ZU3P as below. A.Material with invalid season in the IDOC B.material with valid season in the IDOC. C.With both requested and cancel dates in past.
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be displayed at item level with corresponding season/collection.The delivery block ZS should be displayed at header level in the SO. C.The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future D.Both the changed dates should be displayed at header and item level.
SD-017
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With the blank requested Delivery date .
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days in future at both header and item level.
SD-018
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With the blank cancel date.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The cancel date should be changed to 180 days in future at both header and item level.
SD-019
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC. B.With both blank requested and cancel dates.
 The SO should be created with ZD rejection reason at the item level with blank season/collection. The delivery block ZS should be displayed at header level in the SO. The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future .Both the changed dates should be displayed at header and item level.
SD-020
 Create EDI Order ZOR as below. A.Material with invalid season in the IDOC B.material with valid season in the IDOC. C.With both blank requested and cancel dates.
 The SO should be created as below. A.The rejection reason ZD should be displayed at the item level with blank season/collection. B.The rejection reason ZD should be displayed at item level with corresponding season/collection.The delivery block ZS should be displayed at header level in the SO. C.The requested delivery date should be changed to 180 days and cancel date should be changed to 210 days in future D.Both the changed dates should be displayed at header and item level.

Solution Details

[Provide complete technical details for configuration or programming here]
1. Insert Rejection Reason 'ZS' in case item have invalid season, Update Delivery Block 'ZS' if any of the items has invalid season
Implemented customer exit - EXIT_SAPLJ4AS_004 to insert rejection reason to items which has invalid season and Update Delivery Block if any item has invalid season
Implemented Enhancement Point Z_INV_SEASON_DETER to change the AFS season processing message type from 'Error' to 'Warning'
- Added logic to check valid season for material, in case there is no valid season for the material then insert rejection reason 'ZS' (in case item does not have ZD rejection reason), update Delivery block as 'ZS' at header level and pass information to Enhancement Point (EXIT_SAPLJ4AS_004)
- Added logic to change the AFS season processing message type from 'E' to 'W' in case if received information from EXIT_SAPLJ4AS_004 (Z_INV_SEASON_DETER)

2. Bump Requested Delivery Date / Cancel Date to future and insert Rejection Reason 'ZD'
Implemented customer exit - EXIT_SAPLJ4AS_002 to bump Requested Delivery Date and/or Cancel Date
- Added logic to bump Requested Delivery Date to 180 days In case requested Delivery Date is in past
- Added logic to bump Cancel Date to 210 days In case Cancel Date is in past
- Added logic to insert Rejection Reason 'ZD' at item level in case if we bump any/all of the above dates (Requested Delivery Date, Cancel Date)

Issues

[List Issues / Bugs identified in configuration or development]